CREATE TABLE [dbo].[TCDOCU_EXPO]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[FE_EMBA] [datetime] NULL,
[ST_IMPR_TRAZ] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TCDOCU_EX__ST_IM__3C34F16F] DEFAULT ('N'),
[DE_MARC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST_FLET_PAGA] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TCDOCU_EX__ST_FL__3E1D39E1] DEFAULT ('N'),
[CO_DEST] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_EMBA] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TI_TERM] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PC_COIN_0002] [numeric] (9, 4) NULL CONSTRAINT [DF__TCDOCU_EX__PC_CO__40058253] DEFAULT ((0)),
[PC_COIN_0001] [numeric] (9, 4) NULL CONSTRAINT [DF__TCDOCU_EX__PC_CO__40F9A68C] DEFAULT ((0)),
[CO_INTE_0002] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_INTE_0001] [dbo].[TD_VC_020] NULL,
[ST_IMPR] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TCDOCU_EX__ST_IM__41EDCAC5] DEFAULT ('N'),
[NU_PEDI] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_GUIA] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_COTI] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_ESTA_DOCU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IM_TOTA] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_TO__43D61337] DEFAULT ((0)),
[IM_FLET] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_FL__44CA3770] DEFAULT ((0)),
[IM_MORA] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_MO__45BE5BA9] DEFAULT ((0)),
[IM_GAFI] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_GA__46B27FE2] DEFAULT ((0)),
[IM_BRUT_INAF] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_BR__47A6A41B] DEFAULT ((0)),
[IM_BRUT_AFEC] [dbo].[TD_NU_016_004] NULL CONSTRAINT [DF__TCDOCU_EX__IM_BR__489AC854] DEFAULT ((0)),
[IM_DCT2] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_DC__498EEC8D] DEFAULT ((0)),
[PC_DCT2] [numeric] (9, 4) NOT NULL CONSTRAINT [DF__TCDOCU_EX__PC_DC__4A8310C6] DEFAULT ((0)),
[IM_DCT1] [numeric] (16, 4) NULL CONSTRAINT [DF__TCDOCU_EX__IM_DC__4B7734FF] DEFAULT ((0)),
[PC_DCT1] [numeric] (9, 4) NOT NULL CONSTRAINT [DF__TCDOCU_EX__PC_DC__4C6B5938] DEFAULT ((0)),
[PC_DCTO_REFE] [numeric] (9, 4) NOT NULL CONSTRAINT [DF__TCDOCU_EX__PC_DC__4D5F7D71] DEFAULT ((0)),
[CO_TRAN] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_AGEN_TRAN] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_ALMA] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_RUCS] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_UBIC_GEDE] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DE_DIRE_DESP] [dbo].[TD_VC_100] NULL,
[CO_UNID] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_UBIC_GEOG] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DE_DIRE] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NO_CLIE] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_CLIE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FE_VENC] [datetime] NULL,
[FE_DESP] [datetime] NULL,
[FE_DOCU] [datetime] NOT NULL,
[CO_BANC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_NOT2] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_NOT1] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_CONS] [dbo].[TD_VC_020] NULL,
[CO_LIST_PREC] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FA_CAMB_BASE] [numeric] (15, 6) NOT NULL,
[FA_CAMB] [numeric] (15, 6) NOT NULL,
[CO_MONE_BASE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_MONE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_COND_PAGO] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_TIEN] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TI_VENT] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TI_FACT] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_DOCU] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TI_DOCU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TCDOCU_EX__CO_US__4E53A1AA] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TCDOCU_EX__FE_US__4F47C5E3] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TCDOCU_EX__CO_US__503BEA1C] DEFAULT (suser_sname()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TCDOCU_EX__FE_US__51300E55] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCDOCU_EXPO] WITH NOCHECK ADD CONSTRAINT [CK__TCDOCU_EX__ST_FL__3F115E1A] CHECK NOT FOR REPLICATION (([ST_FLET_PAGA]='N' OR [ST_FLET_PAGA]='S'))
GO
ALTER TABLE [dbo].[TCDOCU_EXPO] WITH NOCHECK ADD CONSTRAINT [CK__TCDOCU_EX__ST_IM__3D2915A8] CHECK NOT FOR REPLICATION (([ST_IMPR_TRAZ]='N' OR [ST_IMPR_TRAZ]='S'))
GO
ALTER TABLE [dbo].[TCDOCU_EXPO] WITH NOCHECK ADD CONSTRAINT [CK__TCDOCU_EX__ST_IM__42E1EEFE] CHECK NOT FOR REPLICATION (([ST_IMPR]='N' OR [ST_IMPR]='S'))
GO
ALTER TABLE [dbo].[TCDOCU_EXPO] ADD CONSTRAINT [PK__TCDOCU_E__17D9AB47121F8769] PRIMARY KEY CLUSTERED  ([CO_EMPR]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCDOCU_EXPO] ADD CONSTRAINT [FK__TCDOCU_EX__CO_EM__056F97C1] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
